package com.example.tse.rbyair.db;

public class DBConstants {

	/** 数据库名称 */
	public static final String DATABASE_NAME = "rbyairapp.db";
	/** 数据库版本 */
	public static final int DATABASE_VERSION = 1;


	/**
	 * user table
	 */
	public static final String TB_USER = "user";//tableName
	public static final String U_ID = "memberId";//UserID
	public static final String U_NICKNAME = "nickname";//用戶名
	public static final String U_AVATAR="avatar";//头像
	public static final String U_SEX = "sex";//性别
	
	/**
	 * 浏览记录(我的足迹)
	 */
	public static final String TB_GOODS = "history";
	public static final String GOODS_ID = "goods_id";
	public static final String GOODS_PRODUCTID = "product_id";
	public static final String GOODS_NAME = "goods_name";
	public static final String GOODS_PRICE = "goods_price";
	public static final String GOODS_MKTPRICE = "goods_mktprice";
	public static final String GOODS_PICS = "goods_pics";

	public static final String CREATE_TB_USER = "create table " 
	        + TB_USER + " ( " 
	         + U_ID + "  varchar(800)  ,"
	         + U_NICKNAME + "  varchar(800)  ,"
	         + U_AVATAR + "  varchar(800)  ,"
			+ U_SEX + "  Integer  " + " ) ";
	
	
	public static final String CREAT_TB_HISTORY = "create table "
			+TB_GOODS + " ( "
			+GOODS_ID + " varchar(800) ,"
			+GOODS_PRODUCTID + " varchar(800) ,"
			+GOODS_NAME + " varchar(800) ,"
			+GOODS_PRICE + " varchar(800) ,"
			+GOODS_MKTPRICE + " varchar(800) ,"
			+GOODS_PICS + " varchar(800) "+" ) ";
}